load data
truncate
into table CRST_HR_ALL_POSITIONS_F
fields terminated by "	"
trailing nullcols 
(
POSITION_ID                 , 
EFFECTIVE_START_DATE        Date 'YYYYMMDD HH24:MI:SS', 
EFFECTIVE_END_DATE          Date 'YYYYMMDD HH24:MI:SS', 
AVAILABILITY_STATUS_ID      , 
BUSINESS_GROUP_ID           , 
ENTRY_GRADE_ID              , 
ENTRY_GRADE_RULE_ID         , 
ENTRY_STEP_ID               , 
JOB_ID                      , 
LOCATION_ID                 , 
ORGANIZATION_ID             , 
PAY_BASIS_ID                , 
PAY_FREQ_PAYROLL_ID         , 
POSITION_DEFINITION_ID      , 
POSITION_TRANSACTION_ID     , 
PRIOR_POSITION_ID           , 
RELIEF_POSITION_ID          , 
SUCCESSOR_POSITION_ID       , 
SUPERVISOR_ID               , 
SUPERVISOR_POSITION_ID      , 
AMENDMENT_DATE              Date 'YYYYMMDD HH24:MI:SS', 
AMENDMENT_RECOMMENDATION    , 
AMENDMENT_REF_NUMBER        , 
AVAIL_STATUS_PROP_END_DATE  Date 'YYYYMMDD HH24:MI:SS', 
BARGAINING_UNIT_CD          , 
COMMENTS                    , 
COPIED_TO_OLD_TABLE_FLAG    , 
CURRENT_JOB_PROP_END_DATE   Date 'YYYYMMDD HH24:MI:SS', 
CURRENT_ORG_PROP_END_DATE   Date 'YYYYMMDD HH24:MI:SS', 
DATE_EFFECTIVE              Date 'YYYYMMDD HH24:MI:SS', 
DATE_END                    Date 'YYYYMMDD HH24:MI:SS', 
EARLIEST_HIRE_DATE          Date 'YYYYMMDD HH24:MI:SS', 
FILL_BY_DATE                Date 'YYYYMMDD HH24:MI:SS', 
FREQUENCY                   , 
FTE                         , 
MAX_PERSONS                 , 
NAME                        , 
OVERLAP_PERIOD              , 
OVERLAP_UNIT_CD             , 
PAY_TERM_END_DAY_CD         , 
PAY_TERM_END_MONTH_CD       , 
PERMANENT_TEMPORARY_FLAG    , 
PERMIT_RECRUITMENT_FLAG     , 
POSITION_TYPE               , 
POSTING_DESCRIPTION         , 
PROBATION_PERIOD            , 
PROBATION_PERIOD_UNIT_CD    , 
PROPOSED_FTE_FOR_LAYOFF     , 
PROPOSED_DATE_FOR_LAYOFF    Date 'YYYYMMDD HH24:MI:SS', 
REPLACEMENT_REQUIRED_FLAG   , 
REVIEW_FLAG                 , 
SEASONAL_FLAG               , 
SECURITY_REQUIREMENTS       , 
STATUS                      , 
TERM_START_DAY_CD           , 
TERM_START_MONTH_CD         , 
TIME_NORMAL_FINISH          , 
TIME_NORMAL_START           , 
UPDATE_SOURCE_CD            , 
WORKING_HOURS               , 
WORKS_COUNCIL_APPROVAL_FLAG , 
WORK_PERIOD_TYPE_CD         , 
WORK_TERM_END_DAY_CD        , 
WORK_TERM_END_MONTH_CD      , 
INFORMATION1                , 
INFORMATION2                , 
INFORMATION3                , 
INFORMATION4                , 
INFORMATION5                , 
INFORMATION6                , 
INFORMATION7                , 
INFORMATION8                , 
INFORMATION9                , 
INFORMATION10               , 
INFORMATION11               , 
INFORMATION12               , 
INFORMATION13               , 
INFORMATION14               , 
INFORMATION15               , 
INFORMATION16               , 
INFORMATION17               , 
INFORMATION18               , 
INFORMATION19               , 
INFORMATION20               , 
INFORMATION21               , 
INFORMATION22               , 
INFORMATION23               , 
INFORMATION24               , 
INFORMATION25               , 
INFORMATION26               , 
INFORMATION27               , 
INFORMATION28               , 
INFORMATION29               , 
INFORMATION30               , 
INFORMATION_CATEGORY        , 
ATTRIBUTE1                  , 
ATTRIBUTE2                  , 
ATTRIBUTE3                  , 
ATTRIBUTE4                  , 
ATTRIBUTE5                  , 
ATTRIBUTE6                  , 
ATTRIBUTE7                  , 
ATTRIBUTE8                  , 
ATTRIBUTE9                  , 
ATTRIBUTE10                 , 
ATTRIBUTE11                 , 
ATTRIBUTE12                 , 
ATTRIBUTE13                 , 
ATTRIBUTE14                 , 
ATTRIBUTE15                 , 
ATTRIBUTE16                 , 
ATTRIBUTE17                 , 
ATTRIBUTE18                 , 
ATTRIBUTE19                 , 
ATTRIBUTE20                 , 
ATTRIBUTE21                 , 
ATTRIBUTE22                 , 
ATTRIBUTE23                 , 
ATTRIBUTE24                 , 
ATTRIBUTE25                 , 
ATTRIBUTE26                 , 
ATTRIBUTE27                 , 
ATTRIBUTE28                 , 
ATTRIBUTE29                 , 
ATTRIBUTE30                 , 
ATTRIBUTE_CATEGORY          , 
REQUEST_ID                  , 
PROGRAM_APPLICATION_ID      , 
PROGRAM_ID                  , 
PROGRAM_UPDATE_DATE         Date 'YYYYMMDD HH24:MI:SS', 
CREATED_BY                  , 
CREATION_DATE               Date 'YYYYMMDD HH24:MI:SS', 
LAST_UPDATED_BY             , 
LAST_UPDATE_DATE            Date 'YYYYMMDD HH24:MI:SS', 
LAST_UPDATE_LOGIN           , 
OBJECT_VERSION_NUMBER       
)
 